The result set from a Less Than join includes all records in which the linked field value in the primary table is less than the linked field value in the lookup table. Using the Less Than join, you can compare sales representative and manager salaries in a different direction. Once again, the Salary field in each table is used as the link field. This time, though, you link from the Manager table to the SalesRep table using a Less Than join on the linked Salary fields:
SELECT Manager.'Last Name', Manager.'Salary', SalesRep.'Last Name', SalesRep.'Salary' FROM 'Manager' Manager', SalesRep' SalesRep WHERE Manager.'Salary' < SalesRep.'Salary'
This SQL statement produces a slightly different table than that produced by the Greater Than join:
Manager Table | Manager Table | SalesRep Table | SalesRep Table |
---|---|---|---|
Last Name | Salary | Last Name | Salary |
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |